inherited FPesquisaMovimentoContabilidadeCP: TFPesquisaMovimentoContabilidadeCP
  Left = 261
  Top = 140
  Caption = 'Pesquisa Movimento Contabilidade Contas Pagar'
  ClientHeight = 285
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 13
  inherited Panel2: TPanel
    inherited BtnLimpar: TBitBtn
      OnClick = BtnLimparClick
    end
    inherited BtnImprimir: TBitBtn
      OnClick = BtnImprimirClick
    end
    inherited BtnSelecionar: TBitBtn
      Enabled = False
    end
  end
  inherited Panel1: TPanel
    Height = 244
    object Label2: TLabel [0]
      Left = 4
      Top = 1
      Width = 54
      Height = 13
      Caption = 'Fornecedor'
    end
    object Label9: TLabel [1]
      Left = 5
      Top = 37
      Width = 85
      Height = 13
      Caption = 'Data Lan'#231'amento'
    end
    object Label6: TLabel [2]
      Left = 97
      Top = 57
      Width = 6
      Height = 13
      Caption = 'a'
    end
    object Label10: TLabel [3]
      Left = 6
      Top = 94
      Width = 46
      Height = 13
      Caption = 'Empresas'
    end
    object Label1: TLabel [4]
      Left = 206
      Top = 37
      Width = 82
      Height = 13
      Caption = 'Data Vencimento'
    end
    object Label3: TLabel [5]
      Left = 296
      Top = 56
      Width = 6
      Height = 13
      Caption = 'a'
    end
    object Label5: TLabel [6]
      Left = 325
      Top = 1
      Width = 42
      Height = 13
      Caption = 'Situa'#231#227'o'
    end
    inherited DBGrid1: TDBGrid
      Top = 148
      Height = 75
      TabOrder = 8
    end
    inherited Panel3: TPanel
      Top = 223
      TabOrder = 9
    end
    object DBLCBFornecedor: TDBLookupComboBox
      Left = 4
      Top = 14
      Width = 314
      Height = 21
      KeyField = 'FORN_CODIGO'
      ListField = 'FORN_RAZAO'
      ListSource = DSDFornecedor
      TabOrder = 0
      OnKeyDown = DBLCBFornecedorKeyDown
    end
    object DEDataIni: TDateEdit
      Left = 6
      Top = 53
      Width = 88
      Height = 21
      NumGlyphs = 2
      TabOrder = 2
    end
    object DEDataFim: TDateEdit
      Left = 105
      Top = 53
      Width = 90
      Height = 21
      NumGlyphs = 2
      TabOrder = 3
    end
    object CkBTodasEmpresas: TCheckBox
      Left = 6
      Top = 76
      Width = 118
      Height = 17
      Caption = 'Todas as Empresas'
      TabOrder = 6
      OnClick = CkBTodasEmpresasClick
    end
    object CLBEmpresas: TCheckListBox
      Left = 1
      Top = 108
      Width = 411
      Height = 40
      Align = alBottom
      Columns = 1
      ItemHeight = 13
      TabOrder = 7
    end
    object DEDataIniVenc: TDateEdit
      Left = 206
      Top = 53
      Width = 88
      Height = 21
      NumGlyphs = 2
      TabOrder = 4
    end
    object DEDataFimVenc: TDateEdit
      Left = 309
      Top = 53
      Width = 90
      Height = 21
      NumGlyphs = 2
      TabOrder = 5
    end
    object CBSituacao: TComboBox
      Left = 325
      Top = 14
      Width = 83
      Height = 21
      ItemHeight = 13
      ItemIndex = 0
      TabOrder = 1
      Text = 'Todos'
      Items.Strings = (
        'Todos'
        'Em aberto'
        'Pagos')
    end
  end
  inherited QPesquisa: TQuery
    SQL.Strings = (
      
        'Select CP_CODIGO as Titulo,CP_DATATITULO as data,CP_DATAVENCIMEN' +
        'TO as dataVencimento,CP_HISTORICO1 as hist1,CP_HISTORICO2 as his' +
        't2,Cp_VALOR as valor,CP_fornecedor as CodFornecedor,Fornecedor.F' +
        'orn_Razao as fornecedor,PLANOCONTAS.ESTRUTURA as estrutura'
      
        ',PLANOCONTAS.DESCRICAO as plano,PLANOCONTAS.NATUREZA as natureza' +
        ',CENTROCUSTO.DESCRICAO as centro'
      
        ',PLANOCONTABILIDADE.PLANOCONT_CODIGOREDUZIDO as TituloCodigoRedu' +
        'zido,PLANOCONTABILIDADE.PLANOCONT_DESCRICAO as TituloContaContab' +
        'il'
      ''
      
        'From ContasPagar INNER JOIN PLANOCONTAS ON CP_PLANO =  PLANOCONT' +
        'AS.CODIGO Left JOIN CENTROCUSTO ON CP_CENTROCUSTO = CENTROCUSTO.' +
        'CODIGO'
      
        'Left JOIN PLANOCONTABILIDADE ON CP_CONTACONTABIL = PLANOCONT_COD' +
        'IGO Left JOIN FORNECEDOR on CP_FORNECEDOR = FORN_CODIGO'
      ''
      ''
      
        'Order by CP_fornecedor,Fornecedor.Forn_Razao,CP_DATATITULO,CP_CO' +
        'DIGO,CP_DATAVENCIMENTO,CP_HISTORICO1,CP_HISTORICO2,CP_VALOR,Plan' +
        'oContas.Natureza')
    Left = 128
    Top = 217
  end
  inherited DSPesquisa: TDataSource
    DataSet = QMovimentoContabilidade
    Left = 168
    Top = 217
  end
  object QMovimentoContabilidade: TQuery
    AfterPost = QMovimentoContabilidadeAfterPost
    AfterDelete = QMovimentoContabilidadeAfterDelete
    DatabaseName = 'baseLocal'
    RequestLive = True
    SQL.Strings = (
      'Select * from MOVIMENTOCONTABILIDADECP'
      ''
      'Order by CODFORNECEDOR,FORNECEDOR,TITULO,DATA,ESTRUTURA ')
    Left = 224
    Top = 217
  end
  object QAux: TQuery
    DatabaseName = 'base'
    SQL.Strings = (
      'Select PLANOCONTABILIDADE.PLANOCONT_DESCRICAO as ContaContabil'
      'From'
      
        'CONTACORRENTE INNER JOIN PLANOCONTABILIDADE ON CONTACORRENTE.CON' +
        'T_CORR_CONTACONTABIL = PLANOCONT_CODIGO'
      ''
      '')
    Left = 272
    Top = 217
  end
  object DSDFornecedor: TDataSource
    DataSet = DMGestao.QFornecedor
    Left = 136
    Top = 48
  end
end
